# coding: utf-8
from . import db, BaseModel


class VerifyCode(BaseModel):
    __tablename__ = 'verify_code'

    auto_id = db.Column(db.BigInteger, primary_key=True, info='自增ID')
    verify_code_id = db.Column(db.BigInteger, info='业务主键ID(时间+AutoID)')
    verify_code = db.Column(db.String(20, 'utf8mb4_0900_ai_ci'), info='验证码（4位）')
    is_deleted = db.Column(db.Integer, server_default=db.FetchedValue(), info='验证码是否有效（默认0）：0--是；1--否')
    create_time = db.Column(db.DateTime, server_default=db.FetchedValue(), info='添加记录的时间')
